| BusinessProcessSubscription |
| EntityType | Independent |
| Logical Entity Name | BusinessProcessSubscription |
| Default Table Name | SyServiceProcessSubscription |
| Logical Only | NO |
| Definition | |
| Note |
| BusinessProcessSubscription Attributes |
| Attribute/Logical Rolename | Domain | Datatype | NULL | Definition |
Id |
INTEGER | NO | ||
| Code | CHAR(15) | NO | ||
| Name | VARCHAR(50) | NO | ||
| ExpirationDate | DATETIME | NO | ||
BusinessProcessId |
INTEGER | NO | ||
| IsActive | BIT | NO | ||
LastModifiedUserId |
INTEGER | NO | ||
| CreatedDateTime | DATETIME | NO | ||
| LastModifiedDateTime | DATETIME | NO | ||
| RowVersion | TIMESTAMP/DATE | NO | ||
| IsUserEditable | BIT | NO |
| BusinessProcessSubscription Keys |
| Key Name | Key Type | Keys |
| Nk_SyServiceProcessSubscription_UserID | Inversion Entry | LastModifiedUserId |
| Nk_SyServiceProcessSubscription_SyServiceProcessID | Inversion Entry | BusinessProcessId |
| UK_SyServiceProcessSubscriptionCode | Unique Constraint | Code |
| PK_SyServiceProcessSubscription_SyServiceProcessSubscriptionID | PrimaryKey | Id |
| BusinessProcessSubscription Relationships |
| Parent Relationships: |
| Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype |
| BusinessProcess | Non-Identifying | One To Zero or More | BusinessProcessId | NO | |||
| Staff | Non-Identifying | One To Zero or More | LastModifiedUserId | NO |
| Child Relationships: |
| Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype |
| BusinessProcessJobItineraryLevelDataChange | Non-Identifying | One To Zero or More | NO | ||||
| SyServiceExceptionRoutingRelationship | Non-Identifying | One To Zero or More | NO | ||||
| BusinessProcessJobItineraryLevel | Non-Identifying | One To Zero or More | NO | ||||
| BusinessProcessSubscriptionDetail | Non-Identifying | One To Zero or More | NO | ||||
| SyServiceProcessSubscriptionTaskSchedule | Non-Identifying | One To Zero or More | NO | ||||
| SyServiceSTARExceptionQueue | Non-Identifying | One To Zero or More | NO | ||||
| SyServiceSubscriptionNotificationRelationship | Non-Identifying | One To Zero or More | NO | ||||
| SyServiceSubscriptionExceptionRoutingRelationship | Non-Identifying | One To Zero or More | NO |
| BusinessProcessSubscription Check Constraints |
| Check Constraint Name | CheckConstraint |